const Sequelize = require('sequelize')
const { db } = require('../database/db')

const Goods = db.define('goods',{
    PID:Sequelize.STRING,
    GOODS_SERIAL_NUMBER:Sequelize.STRING,
    SHOP_ID:Sequelize.STRING,
    SUB_ID:Sequelize.STRING,
    GOOD_TYPE:Sequelize.INTEGER,
    STATE:Sequelize.INTEGER,
    IS_DELETE:Sequelize.INTEGER,
    NAME:Sequelize.STRING,
    ORI_PRICE:Sequelize.INTEGER,
    PRESENT_PRICE:Sequelize.INTEGER,
    AMOUNT:Sequelize.INTEGER,
    DETAIL:Sequelize.TEXT,
    BRIEF:Sequelize.STRING,
    SALES_COUNT:Sequelize.INTEGER,
    IMAGE1:Sequelize.STRING,
    IMAGE2:Sequelize.STRING,
    IMAGE3:Sequelize.STRING,
    IMAGE4:Sequelize.STRING,
    IMAGE5:Sequelize.STRING,
    ORIGIN_PLACE:Sequelize.STRING,
    GOOD_SCENT:Sequelize.STRING,
    IS_RECOMMEND:Sequelize.INTEGER,
    PICTURE_COMPERSS_PATH:Sequelize.STRING
})


module.exports = Goods;